package com.yc.mapper;

import com.yc.entity.Categorysecord;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Select;

/**
 * <p>
 * InnoDB free: 4096 kB Mapper 接口
 * </p>
 *
 * @author ly
 * @since 2022-05-25
 */
public interface CategorysecordMapper extends BaseMapper<Categorysecord> {
    @Select("SELECT csname from categorysecord where cid=1 and csid in (SELECT csid from cmap where ctid =#{ctid}) and csid!=1")
    String banner(Integer ctid);

    @Select("SELECT csname from categorysecord where cid=4 and csid in (SELECT csid from cmap where ctid =#{ctid}) and csid!=58")
    String queryEdition(Integer ctid);
}
